BEGIN TRAN

INSERT INTO [ElectricityDaily_Manual]
           ([de_dateTime]
           ,[de_kWhTotal]
           ,[de_kWhDaily]
           ,[de_meterId])
     
           SELECT 
		[de_dateTime]
      ,[de_kWhTotal]
      ,[de_kWhDaily] * .8
      ,15
  FROM [DailyElectricity]
GO

INSERT INTO [ElectricityDaily_Manual]
           ([de_dateTime]
           ,[de_kWhTotal]
           ,[de_kWhDaily]
           ,[de_meterId])
     
           SELECT 
		[de_dateTime]
      ,[de_kWhTotal]
      ,[de_kWhDaily] * .85
      ,14
  FROM [DailyElectricity]
GO

INSERT INTO [ElectricityDaily_Manual]
           ([de_dateTime]
           ,[de_kWhTotal]
           ,[de_kWhDaily]
           ,[de_meterId])
     
           SELECT 
		[de_dateTime]
      ,[de_kWhTotal]
      ,[de_kWhDaily] * .9
      ,13
  FROM [DailyElectricity]
GO

INSERT INTO [ElectricityDaily_Manual]
           ([de_dateTime]
           ,[de_kWhTotal]
           ,[de_kWhDaily]
           ,[de_meterId])
     
           SELECT 
		[de_dateTime]
      ,[de_kWhTotal]
      ,[de_kWhDaily] * .95
      ,12
  FROM [DailyElectricity]
GO


INSERT INTO [ElectricityDaily_Manual]
           ([de_dateTime]
           ,[de_kWhTotal]
           ,[de_kWhDaily]
           ,[de_meterId])
     
           SELECT 
		[de_dateTime]
      ,[de_kWhTotal]
      ,[de_kWhDaily] * 1.2
      ,4
  FROM [DailyElectricity]
GO

INSERT INTO [ElectricityDaily_Manual]
           ([de_dateTime]
           ,[de_kWhTotal]
           ,[de_kWhDaily]
           ,[de_meterId])
     
           SELECT 
		[de_dateTime]
      ,[de_kWhTotal]
      ,[de_kWhDaily] * 1.15
      ,3
  FROM [DailyElectricity]
GO

INSERT INTO [ElectricityDaily_Manual]
           ([de_dateTime]
           ,[de_kWhTotal]
           ,[de_kWhDaily]
           ,[de_meterId])
     
           SELECT 
		[de_dateTime]
      ,[de_kWhTotal]
      ,[de_kWhDaily] * 1.1
      ,2
  FROM [DailyElectricity]
GO

INSERT INTO [ElectricityDaily_Manual]
           ([de_dateTime]
           ,[de_kWhTotal]
           ,[de_kWhDaily]
           ,[de_meterId])
     
           SELECT 
		[de_dateTime]
      ,[de_kWhTotal]
      ,[de_kWhDaily] * 1.05
      ,1
  FROM [DailyElectricity]
GO


INSERT INTO [ElectricityDaily_Manual]
           ([de_dateTime]
           ,[de_kWhTotal]
           ,[de_kWhDaily]
           ,[de_meterId])
     
           SELECT 
		[de_dateTime]
      ,[de_kWhTotal]
      ,[de_kWhDaily] * 1
      ,16
  FROM [DailyElectricity]

ROLLBACK